﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Entity;
using System.Data;
using System.Data.SqlClient;
namespace DataAccess
{
    public class QLDiemTrenLop
    {
        public static DataTable xemdiem(string mamonhoc)
        {
            return DataAccess.ExeStoredWithParamToDataTable("QLDTrenLop", "@MaMonHoc", mamonhoc);
        }
        public static string update(string mamonhoc, string masv,string hocky,float diem1,float diem2,float diem3,float diem4,float diem5,float diemgiuahocphan,float diemchuyencan,float diemtrungbinh,float sotietnghi,string dieukienthi)
        {
            return DataAccess.ExeStoredToString("QLDTrenLop_Update", "@MaMonHoc", mamonhoc, "@MaSinhVien", masv, "@HocKy", hocky, "@Diem1", diem1, "@Diem2", diem2, "@Diem3", diem3, "@Diem4", diem4, "@Diem5", diem5, "@DiemGiuaHocPhan", diemgiuahocphan, "@DiemChuyenCan", diemchuyencan, "@DiemTrungBinh", diemtrungbinh, "@SoTietNghi", sotietnghi, "@DieuKienThi", dieukienthi);
        }
        public static DataTable HienThiTen(string magiangvien)
        {
            return DataAccess.ExeStoredWithParamToDataTable("Hienthimonhoc1", "@MaGiangVien", magiangvien);
        }
        public static string LayMaMonHoc(string tenmonhoc)
        {
            return DataAccess.ExeStoredToString("LayMaMonHoc", "@TenMonHoc", tenmonhoc);
        }
        public static int SoTrinh(string tenmonhoc)
        {
            return DataAccess.ExeStoredToInt("KTDieuKienThi", "@TenMonHoc", tenmonhoc);
        }
    }
}
